<?

$fs_ord_man_customer_information = new Fieldset (array (
	db_conn=>$_GLOBAL_DBH,
	relation=>"ord_man_shipping_information",
	title=>"Customer Information",
	fieldset=>array (
		array (name=>"id",label=>"ID",type=>"numeric",
				value=>$_REQUEST["shipping_information_id"],
				input=>"hidden",primary_key=>true),
		array (name=>"order_id",label=>"State",type=>"any",
				relation=>array(foreign=>"ord_man_orders",key=>"id",
				field=>"name"),
				input=>"select",
				options=>"_app_select_query",
				options_params=>"SELECT id,name FROM ord_man_orders",
				columns=>array (key=>"id",value=>"name"),
		),
		array (name=>"order_date",label=>"Start Acquired",type=>"any",
				input=>"date",value=>_app_date("order_date")),
		array (name=>"ship_address_1",label=>"Shipping Address 1",type=>"alphanumeric",
				input=>"field"),
		array (name=>"ship_address_2",label=>"Shipping Address 2",type=>"alphanumeric",
				input=>"field", optional=>true),
		array (name=>"ship_city",label=>"Shipping City",type=>"character",
				input=>"field"),
		array (name=>"ship_state_id",label=>"Shipping State",type=>"any",
				relation=>array(foreign=>"vertical_acl_test.states",key=>"id",
				field=>"name"),
				input=>"select",
				options=>"_app_select_query",
				options_params=>"SELECT id,name FROM vertical_acl_test.states",
				columns=>array (key=>"id",value=>"name"),
		),
		array (name=>"ship_postal",label=>"Shipping Postal",type=>"numeric",
				input=>"field"),
		array (name=>"ship_country_id",label=>"Shipping Country",type=>"any",
				relation=>array(foreign=>"vertical_acl_test.countries",key=>"id",
				field=>"name"),
				input=>"select",
				options=>"_app_select_query",
				options_params=>"SELECT id,name FROM vertical_acl_test.countries",
				columns=>array (key=>"id",value=>"name"),
		),
		array (name=>"ship_phone_1",label=>"Shipping Phone 1",type=>"phone",
				input=>"field"),
		array (name=>"ship_phone_2",label=>"Shipping Phone 2",type=>"phone",
				input=>"field", optional=>true),
		array (name=>"ship_date",label=>"Date Shipped",type=>"any",
				input=>"date",value=>_app_date("ship_date")),
		array (name=>"ship_received",label=>"Date Received",type=>"any",
				input=>"date",value=>_app_date("ship_received")),
		array (name=>"item_qty",label=>"Item Qty",type=>"numeric",
				input=>"field", optional=>true),
		array (name=>"freight_charge",label=>"Freight Charge",type=>"decimal",
				input=>"field", optional=>true),
		array (name=>"sales_tax_rate",label=>"Sales Tax Rate",type=>"decimal",
				input=>"field", optional=>true),
		array (name=>"shipped",label=>"Shipped",type=>"numeric",
				input=>"field", optional=>true),
	),
));

$fs_ord_man_customer_information->parse ();

?>
